@REM Please install  webdeployment tool first,  http://www.iis.net/expand/WebDeploymentTool 
@REM Usage: SetupBasic <"DB connection string">, such as:
@REM 	SetupBasic.cmd "Server=tcp:SQLAZUREDBNAME.database.windows.net;Database=LocationsDB;User ID=USERNAME;Password=PASSSWORD;Trusted_Connection=False;Encrypt=True;"
@REM 	SetupBasic.cmd "Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Microsoft\public\OlympicApp\MapWayCodePlex\WebRole1\App_Data\LocationsDB.mdf;Integrated Security=True;User Instance=True;"

"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\DataInstall.sql" -dest:dbfullsql=%1
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city1.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\DataInstall2.sql" -dest:dbfullsql=%1
